Items and Inventory

Navigation

Transactions
Inventory Location Transfers	Inventory Adjustments Positive or Negative Adjustments of Items.
Inquiries and Reports
Inventory Item Movements	Inventory Reports
Inventory Item Status Current and Future Item Status.
Maintenance
Master Items	Foreign Item Codes
Item Variants	Sales Kits
Item Categories Items belong to a Category	Units of Measure
Inventory Locations You can have several Item Locations	Reorder Levels
Audit Categories	Import CSV Items
Pricing and Costs
Sales Pricing	Standard Costs Manual Adjustment of Average Costs.
Purchasing Pricing Supplier Prices and other Supplier Data

Tips and Tricks

• If the Import Inventory Items extension is used, then any commas in the csv file's fields (description, etc.,.) should be escaped with a back slash ("\") character.
• List of inventory adjustments: Banking and General Ledger tab => Journal Inquiries => filter by Inventory Adjustments => Enlarge the period as desired
• Purging Old Items: One off items purchased and then sold are best made inactive after the transactions pertaining to them are over.

Inventory Adjustments default account issues

• Problem
  • Create a clearing account for inventory variances where adjustments are posted to.
  • Set the Inventory Adjustments account on the System and GL Info page to be the new account ("5035, Inventory Variance")
  • FA still posts the adjustment to the default account ("5040, Purchase Price Variance")
• Reason and Solution
  • It is very important to setup correct default accounts.
  • The Item Categories use the default setup in System and GL Setup.
  • The items use the item category account for adjustment when creating an item.
  • Therefore if you change the default account in system and gl setup, you will have to change it on categories and items.
  • At least enter all items to change the code or create and use a script for this.

Inventory Only - Raqim Use Case

• Where Raqim is only being used for Inventory Management
• Almost all transactions will be location transfers or negative adjustments
• Reorder email was being sent when a sales event reduces the inventory level at the particular location
• Implemented as of: Reorder email is now also sent when there is a location transfer or negative inventory adjustment and inventory level falls below reorder level

Consignment as Locational Stock

• Use the locations as lots or consignment
• This is the only best solution available in FA for managing such function
• Otherwise inventory and sales modules need customisation to incorporate lot wise functions